SELECT
	CONCAT(e.FirstName, ' ', e.LastName) AS [Employee name],
	ISNULL(m.FirstName + ' ' + m.LastName, 'No manager') AS [Manager name]
		FROM Employees e
	
	LEFT OUTER JOIN Employees m
		ON e.ManagerID = m.EmployeeID